package com.friday.dao;

import java.sql.Date;
import java.util.List;

import com.friday.po.SignIn;



public interface SignInDao {
	
	int insertSignIn(SignIn si) throws Exception;
	
	int deleteSignInById(String id) throws Exception;
	
	int deleteSignInByDate(Date date) throws Exception;
	
	int updateSignIn(SignIn si) throws Exception;
	
	List<SignIn> querySignInByDepartment(String department) throws Exception;
	
	SignIn querySignInByEmployee(String employee) throws Exception;
	
	List<SignIn> querySignInBetweenDate(Date start, Date end) throws Exception;
	
	List<SignIn> querySignInAll() throws Exception;

}
